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