UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ulGHHKNO/8F3vWM/YLf+H3yH6rkDBEW42OGAxmzBMrs='
WHERE
key_id = 'b3a94d0f48a997077fb2531f2a1c0a7da67f26823d8e48f8e32225b0b48fa1c2'
AND (
token = 'ulGHHKNO/8F3vWM/YLf+H3yH6rkDBEW42OGAxmzBMrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)