UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yHG4mVZTgdYPvuNXcisfoNQVDnFquX4Uzey7ot4sfRI='
WHERE
key_id = 'b5c81ba4ad652230435b008961e9d326c7ec333f6b7cd862043d25c9e0097b00'
AND (
token = 'yHG4mVZTgdYPvuNXcisfoNQVDnFquX4Uzey7ot4sfRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)