UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1kODZpZB7FzNKxpiJFn61JpyZd6fwZmR11RGq1V8yjo='
WHERE
key_id = '8738d41f10d7d424cbfd3a85e8bc3b12e0b58a95644b595d7044c7365a23a129'
AND (
token = '1kODZpZB7FzNKxpiJFn61JpyZd6fwZmR11RGq1V8yjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)