UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8XbfXzzmsB9HqMazx5ERKChkNsrbeCPW167OlUX5WmE='
WHERE
key_id = '0e29e8a3ebf1dde509fe1939bbb7b4ccd02976468d55c24e94631f3f9d3d1a54'
AND (
token = '8XbfXzzmsB9HqMazx5ERKChkNsrbeCPW167OlUX5WmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)