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