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