UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGnRpf4WicFNTOcefdocIFrJkNc0BXq0BRrokcM/H3M='
WHERE
key_id = 'bdfb972e622bad27dc330d88fe6443b5ca7fdbf4e24c74155447e931788725bd'
AND (
token = 'VGnRpf4WicFNTOcefdocIFrJkNc0BXq0BRrokcM/H3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)