UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R7JCg3LC6iojiVTh4Va+mSEmcHkfE5GHE+lSOn8f+Gg='
WHERE
key_id = '0df7906e0d319c90b5dbd625114168aa3f7877c1a75909cffcd00a677c45773f'
AND (
token = 'R7JCg3LC6iojiVTh4Va+mSEmcHkfE5GHE+lSOn8f+Gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)