UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1rjhsoAPhLszl2GnxcLjiIEQgFYkEsuoceJCIh+lZlY='
WHERE
key_id = '4a612691ae62e91e654507f3687c67d61bdfa55b0a052e82699ff03c31b4715c'
AND (
token = '1rjhsoAPhLszl2GnxcLjiIEQgFYkEsuoceJCIh+lZlY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)