UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6dwrRZ4QjebVfNSK6p7vjF5o6lQHyIM/OHCoikwJkGI='
WHERE
key_id = '0c179b5b3f2721f4fe5ea6d0ff16e154bb1b0b5bff984498b7c200efda545835'
AND (
token = '6dwrRZ4QjebVfNSK6p7vjF5o6lQHyIM/OHCoikwJkGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)