UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ALsY12nMup1B2V399ZLelQxo70r66tW3v1lgvCS+/U='
WHERE
key_id = 'ec5ec2209a3a95653833abb0de9d314abe2cc04da4e2cbee70c6ad5fbed387ec'
AND (
token = '0ALsY12nMup1B2V399ZLelQxo70r66tW3v1lgvCS+/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)