UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xkkm8cUR7hgULNvZTDG5L/PU9F9AlUXVHrSN/QLYATY='
WHERE
key_id = 'ec55b41e763696c0c4f861799b79ac38ab6b1d166e2516268d3023cdb70f7599'
AND (
token = 'Xkkm8cUR7hgULNvZTDG5L/PU9F9AlUXVHrSN/QLYATY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)