UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BE6DSTRvVLFMwgdHIEArlRw1GSZX+M74RYAWxv+dQyI='
WHERE
key_id = 'a04ac0455f0c82b5d61e8aee1276ad3801b1e9f3a2d278117c8916639622ab65'
AND (
token = 'BE6DSTRvVLFMwgdHIEArlRw1GSZX+M74RYAWxv+dQyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)