UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C9xzFA+BO5y2j9mAY+JaB0CSn5Adf4pJpq+VDx+sUZQ='
WHERE
key_id = '1afd0df47bd72716c07417cbe9a55e80e950f8ded9f528575c950dea143e1113'
AND (
token = 'C9xzFA+BO5y2j9mAY+JaB0CSn5Adf4pJpq+VDx+sUZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)