UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HvTY/NxYS59I8nUIq0o6CLhbDor0xHfpzJELPiIVf2k='
WHERE
key_id = '78c8cdb471547f0602661051db64318f35e876fe4a6e3f3a98e0ebb72565be89'
AND (
token = 'HvTY/NxYS59I8nUIq0o6CLhbDor0xHfpzJELPiIVf2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)