UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIkG6cs54PQHvwdAhf2tCgHw9fj7nNnFD7+4rp2d7g0='
WHERE
key_id = 'acd9a69c820f55dfc68d547fdca4d01842f464ca7574b28b89763dfc8ee4762e'
AND (
token = 'mIkG6cs54PQHvwdAhf2tCgHw9fj7nNnFD7+4rp2d7g0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)