UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mWRe6t18rGxFndqdWY1/1XPhC/kp1mSVMTxuU7nMdYE='
WHERE
key_id = '9ecf5202ebe983aa73e497fa908875160c2517abe3c6c0bb31adf781399cd912'
AND (
token = 'mWRe6t18rGxFndqdWY1/1XPhC/kp1mSVMTxuU7nMdYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)