UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kX2IsJkOY77yjJv2WjSz3iPNUKAo8E16pw321XPuIow='
WHERE
key_id = '9e14a04878863c5621dd2f32711a97e4cb2eec6dde49d4bfcfb8a8e185262aa9'
AND (
token = 'kX2IsJkOY77yjJv2WjSz3iPNUKAo8E16pw321XPuIow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)