UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXGHTNrURogFUD5wmcaXNzKGa22dzvgegdVQuD6QRIU='
WHERE
key_id = 'aec313f00614c00df3e7cb6aba7299433b02696f9f9adbb845f7bf9d86c03b7a'
AND (
token = 'WXGHTNrURogFUD5wmcaXNzKGa22dzvgegdVQuD6QRIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)