UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UFxrNxEISsB6dwb61VvbEM27MRX2X8cr0Q6U3MWu4Gw='
WHERE
key_id = '17b4b8a50a02bc9f30bb9485c1e52aae27c47f9f31ae035d35ab5b92eb07b61e'
AND (
token = 'UFxrNxEISsB6dwb61VvbEM27MRX2X8cr0Q6U3MWu4Gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)