UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mFxMnjcNphsz58PF16mNeSIwTPj9kdRamrYM9sHtxtI='
WHERE
key_id = '3a1bcf84786cb3359969e7596453e3e778d08c8abe4a1ecec7e254551cb68774'
AND (
token = 'mFxMnjcNphsz58PF16mNeSIwTPj9kdRamrYM9sHtxtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)