UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uWv8zHH+VL8UCQiVeFlB87PxhQoQormsbX+B3jpDwxQ='
WHERE
key_id = 'afe2d3896e8274886b4e75f78c3ca6a869244a73ec463c42591ed0596a6b67cc'
AND (
token = 'uWv8zHH+VL8UCQiVeFlB87PxhQoQormsbX+B3jpDwxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)