UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bVF9QaYQwi1p04VOsf0EwQfufhZrZ+hOhWkjlBri5xw='
WHERE
key_id = '038ea718f0cec9061dc11304a7383f56b4c2209a2206a1b2df0e9e3712a1421e'
AND (
token = 'bVF9QaYQwi1p04VOsf0EwQfufhZrZ+hOhWkjlBri5xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)