UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9xOU/aI8B88MyIeldFuhQh1jWIxkRqHJvz1zfpSXX/A='
WHERE
key_id = '1878486e9a5bd13f6812b69279935ece86cf3c85558f1c3c39d0d4650750f8b6'
AND (
token = '9xOU/aI8B88MyIeldFuhQh1jWIxkRqHJvz1zfpSXX/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)