UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TOIuvPTo+ybzmpeJkpCixcRRpC4JfSPGhNxpHeoUmk='
WHERE
key_id = 'a101da1b4cc3e201931bb9713c55778e9e70d23d6d7d0453edd86c1cb4496c6a'
AND (
token = '6TOIuvPTo+ybzmpeJkpCixcRRpC4JfSPGhNxpHeoUmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)