UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PCzKE25CGgME9UED4BVBlFnqtoHoSRlzvvLqdzMhADw='
WHERE
key_id = '9babfd7c6f261c24792f2d967ea540ccdf21b91c4abb4214f36d33083330ff92'
AND (
token = 'PCzKE25CGgME9UED4BVBlFnqtoHoSRlzvvLqdzMhADw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)