UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pcOZFJU04wdA0pkiduEuMxMN8b5S461ATLpTUTg3ufA='
WHERE
key_id = '97ba5b89ee8233c34ffa587f8337e2d7eb697209748259bcf29e3794c00efc8a'
AND (
token = 'pcOZFJU04wdA0pkiduEuMxMN8b5S461ATLpTUTg3ufA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)