UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5DXwx5t4nO5WhbDH9TBcY7Klb0PBRifoObDs2HXzqw8='
WHERE
key_id = '78c87fb114dda5fe86db4068c31a833fbf93ac928641b445e213984df0fe2355'
AND (
token = '5DXwx5t4nO5WhbDH9TBcY7Klb0PBRifoObDs2HXzqw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)