UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5r6MEJC/Jmidkivj3fGoVKEhMrCNQmbSoPHzL03aXew='
WHERE
key_id = '10b86908d72e7fd66410aec073daea8b17b4785ce5494a4cc5b66bef5d04c6de'
AND (
token = '5r6MEJC/Jmidkivj3fGoVKEhMrCNQmbSoPHzL03aXew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)