UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fYHfXMgBiwfKu45boB11jlqMy7NLgXLDbKofxSMVfYE='
WHERE
key_id = '03671cfb97f02b69599202b50bf2bdf7f85167eaf81d086789ee22206fe3559a'
AND (
token = 'fYHfXMgBiwfKu45boB11jlqMy7NLgXLDbKofxSMVfYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)