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