UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '98iK0hsImXb6PBgsSdqdhSCMVS6D9m7dhhu0nW09H48='
WHERE
key_id = 'a682ebfbebe98fb8e5eedc54fb9564bf43e57c1f3c4a024b048765ce2e3b7da2'
AND (
token = '98iK0hsImXb6PBgsSdqdhSCMVS6D9m7dhhu0nW09H48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)