UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htvb9fpbo7jPHdssqv54EgqcRgp2tcGEPEUK+94kAXY='
WHERE
key_id = '314987d8ccfcbf8177bd030670f1b1ab91da1aa05911b429c15aa06b5d2bf905'
AND (
token = 'htvb9fpbo7jPHdssqv54EgqcRgp2tcGEPEUK+94kAXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)