UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TjLlPvK8pkPsp5h50g7YGOCvSoPJ9b92dM7s5LOFmN0='
WHERE
key_id = 'a6f2e0e959a445851ac6e48afe47c48e63be53aea83129f1d1ce9ac9050dbf00'
AND (
token = 'TjLlPvK8pkPsp5h50g7YGOCvSoPJ9b92dM7s5LOFmN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)